﻿CREATE VIEW [dbo].[AuthorView]
	AS
	select	a.ID as AuthorId,
			(select COUNT(*) from BookAuthor as ba where ba.AuthorId = a.ID) as BookCount,
			a.Born,
			a.Died,
			a.FirstName,
			a.LastName
	from	Author as a;
	